UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EfvWhCNE5Sl46ok9rtWNjmnEpG4x/mIHDm8Y/+bejqs='
WHERE
key_id = 'dd6b0aef80c1bf3cac03bb1447879f963286be21df36483ba5d8905bfe863f22'
AND (
token = 'EfvWhCNE5Sl46ok9rtWNjmnEpG4x/mIHDm8Y/+bejqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)