UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1JaWeOFH7reA+oQeCEUIu12SkYIc2bUWijnX1z9ykpU='
WHERE
key_id = 'a769d3b5b123c046a6d26738a5c769f36952dca56b81fa6728c7cdc1eb7c5870'
AND (
token = '1JaWeOFH7reA+oQeCEUIu12SkYIc2bUWijnX1z9ykpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)