UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z4g6Tso9i6Tgx4Vi7cJtzONiAmU6XZGIBf6ganyOKAA='
WHERE
key_id = '1bdbb7a89cfe35e8bf7214959a64d1aa61b26124cc058054ed85de2725868174'
AND (
token = 'z4g6Tso9i6Tgx4Vi7cJtzONiAmU6XZGIBf6ganyOKAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)