UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2xJVXe4Ke5T384kb+QzqWEcbQSjNHNDLbTVYA1YnfcA='
WHERE
key_id = '492547fee9a843681a063364569233e60632b6f6c9d2ffd3dc668beda9678ab0'
AND (
token = '2xJVXe4Ke5T384kb+QzqWEcbQSjNHNDLbTVYA1YnfcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)