UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fwSmtnkkIjJ175pxqpS3lcEqztUMcBcLYrulRQAOlbY='
WHERE
key_id = '8db58a93184c3e78457e67ea3455a0ce85b72dcc7c032e623fb7b601fd594234'
AND (
token = 'fwSmtnkkIjJ175pxqpS3lcEqztUMcBcLYrulRQAOlbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)