UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BNzl5qJy8FV7GrAPafLVe84lx/NfYnBJOauSa6UvMhM='
WHERE
key_id = 'a879d56c9bda658b4fa6e6c6f2ec7ec00f361c68793484c4212ff8b8a93e9d0b'
AND (
token = 'BNzl5qJy8FV7GrAPafLVe84lx/NfYnBJOauSa6UvMhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)