UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVdZqHkMJY1uV3H+mbFenWVo4sr2TUkdGNCwdQG+Um8='
WHERE
key_id = 'd0755712dd4c09d98eb2d456b6d32562021ec844be826869edc3d5e912767b4a'
AND (
token = 'pVdZqHkMJY1uV3H+mbFenWVo4sr2TUkdGNCwdQG+Um8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)