UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a/+WSovCDe9lW7Iiy1UdjxUts4yi7AabD5Mfadew/UA='
WHERE
key_id = 'e96059a96e0a4d9e63cda0b320b0ee93315d992e43f54843fe11a1c9de70c2a6'
AND (
token = 'a/+WSovCDe9lW7Iiy1UdjxUts4yi7AabD5Mfadew/UA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)