UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nn/degVIDmfTImHV2nhZohHZ5t8E51IXEsrefad7hoU='
WHERE
key_id = 'bae4ddcc96e9643861af128dc5b327d081c2b1f71ae3f31e7865ae2eea6f87d3'
AND (
token = 'Nn/degVIDmfTImHV2nhZohHZ5t8E51IXEsrefad7hoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)