UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHC+QtiU1lKHlZBcOh9g07smyNrnl54TauZJDP4zTvY='
WHERE
key_id = '41c9a9b6c4fdeb5952f5197843020c1b514950a4e7ed538c01ba04e1d3bb7173'
AND (
token = 'zHC+QtiU1lKHlZBcOh9g07smyNrnl54TauZJDP4zTvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)