UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKdprfsQyM/XbvJDfH8gHNNPu+n27YrmidIH4Whz98M='
WHERE
key_id = 'a21c5de48e538a00c6883147ee1a281b471defd4716ba23327e022198cb84e11'
AND (
token = 'ZKdprfsQyM/XbvJDfH8gHNNPu+n27YrmidIH4Whz98M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)