UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ABzaHW9+fs03tOBT7BmKOq7YQdad/cFDoEDDkRD/HxI='
WHERE
key_id = 'f30f6aae56f86382b98f0dd565edbaf02599af7f3363f41287fa02e1e02272b6'
AND (
token = 'ABzaHW9+fs03tOBT7BmKOq7YQdad/cFDoEDDkRD/HxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)