UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xn2wQZfaVcXmaZpStrqGkr8Vw2vbtjufdW92C+2D2pM='
WHERE
key_id = 'bca27b0816c296aa1ea9f4250cef89e4b8ed9fe27dabb53f0085fd9b7031b599'
AND (
token = 'xn2wQZfaVcXmaZpStrqGkr8Vw2vbtjufdW92C+2D2pM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)