UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YGg5OGvGB5c+5deI57eoETkCC4PFMiwcs02zmUnqAGE='
WHERE
key_id = '0c7fd5eecb087babb548296abf4dcf4e295fe1fe7fe0ea934c198e568a3910fe'
AND (
token = 'YGg5OGvGB5c+5deI57eoETkCC4PFMiwcs02zmUnqAGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)