UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CannDqFNKLO+4X8S9dYgY+P7gVlS0xHwcyj2LulcE0g='
WHERE
key_id = 'bc839218538480a4dcae07e69d382cc1c45a9c1d978096183a533ad5976d33a0'
AND (
token = 'CannDqFNKLO+4X8S9dYgY+P7gVlS0xHwcyj2LulcE0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)