UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47m4GtM3t8EXUTg37ThZbgAYsv+5qry+YpsaBJVgy40='
WHERE
key_id = 'd1bfcb171e43f8ac06ff9a507637ded29e05b00785dded64d637fef1cf7adb03'
AND (
token = '47m4GtM3t8EXUTg37ThZbgAYsv+5qry+YpsaBJVgy40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)