UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dmqKeLRbfNpL45gcJZl5t0tR52E/zfeSV6T8wGnbwSk='
WHERE
key_id = '0f0abc77457161ff0c3467d410510a9e23be27342aad88dd36e0ae6fd7ad5745'
AND (
token = 'dmqKeLRbfNpL45gcJZl5t0tR52E/zfeSV6T8wGnbwSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)