UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BvfkOqrK1rAKovitOkmBs1xqTHiARzIz/k88CJRDmNE='
WHERE
key_id = 'b75ed43767e943bc62c568c7851632e6a300220425484cf6830caae4fa9f8d40'
AND (
token = 'BvfkOqrK1rAKovitOkmBs1xqTHiARzIz/k88CJRDmNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)