UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQcJkAOWa7Osinjn9Zq760H61kXXXci0pg82XYwrOFo='
WHERE
key_id = '18f04cdc9e46edf13c39586526d4b9c5cd1baf6b50becf64f90de252164c7155'
AND (
token = 'nQcJkAOWa7Osinjn9Zq760H61kXXXci0pg82XYwrOFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)