UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJW7XqrzhwlidFO8aW9hABTZgykfKgChQB1UfiZx01Y='
WHERE
key_id = '54836f879b89e9f3aeca58b09a91ea5f14fac1f21b45c3d0b21c0d4c480f0fbd'
AND (
token = 'ZJW7XqrzhwlidFO8aW9hABTZgykfKgChQB1UfiZx01Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)