UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/PxzdSXOVqAf10RL4m369FcBglfGgIIZFDkJ0Y1+Q9s='
WHERE
key_id = '5199b077733595c6981207c9a6fe6b08da44ed910c057dbc0131dcf12a6d417e'
AND (
token = '/PxzdSXOVqAf10RL4m369FcBglfGgIIZFDkJ0Y1+Q9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)