UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qIcPjXE/h8tfuhNTIeZT7896sd7z5mfSk6UJoYD1aU8='
WHERE
key_id = '686098dd2fefea458eb03086d92d5fc2cd88c0b2c865094c4beaca7e11fc3734'
AND (
token = 'qIcPjXE/h8tfuhNTIeZT7896sd7z5mfSk6UJoYD1aU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)