UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CDzruUpIwhxWXkCJUkt/VmdzSTgZXENWZlu1kLqDHTU='
WHERE
key_id = '482a711758b775bc90328cedb4f6c96190fb4d4d0babf403bca88ff32b80a3b2'
AND (
token = 'CDzruUpIwhxWXkCJUkt/VmdzSTgZXENWZlu1kLqDHTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)