UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uH7erKRlsi5evbHa1a2fVUQ8CsEbKAvYiLPxZ/wc3ms='
WHERE
key_id = '05caecc6175e9a94e5319ce336a4a871c2a81b27e390d34626c3f651fbf33727'
AND (
token = 'uH7erKRlsi5evbHa1a2fVUQ8CsEbKAvYiLPxZ/wc3ms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)