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