UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f9c6AH2eztNdUoIBX+Xd/ydwkhcDbsw+MUkmoAWg5aU='
WHERE
key_id = '3bd9916c7457e45eda5b3b50aaacf5f7509cc34501dc6ba7ef6f99c42a101bd1'
AND (
token = 'f9c6AH2eztNdUoIBX+Xd/ydwkhcDbsw+MUkmoAWg5aU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)