UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8b9i75LtuLDHQIQc5xO5ehxbUS1JD1usI4NxggPPans='
WHERE
key_id = '5168b0200b2b8b45e35da653c3945ccd521bcef8f2f29575e67c348976367f8f'
AND (
token = '8b9i75LtuLDHQIQc5xO5ehxbUS1JD1usI4NxggPPans='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)