UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C391e8iFjV7Bp+LFaM13cQJGjRUE4cUrv26Jf3OZgGc='
WHERE
key_id = 'aaf844daa88fa41c919768fa44eedaac1b4c916e8ed181bce5000fced1fb7a97'
AND (
token = 'C391e8iFjV7Bp+LFaM13cQJGjRUE4cUrv26Jf3OZgGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)