UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zWGdKH66cni9ZEWj1axaQWHkoV+KHZfrQHZ249J0umo='
WHERE
key_id = '5e85ca89f46652a6b6c0ab0e797028f820a2b727a42af690543dce9fd15a8e2d'
AND (
token = 'zWGdKH66cni9ZEWj1axaQWHkoV+KHZfrQHZ249J0umo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)