UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HmDqk3NSY/FuG+i5sJHCwnhVG2JZyEhT5oTVBKNUBto='
WHERE
key_id = 'b31c7b828ba7bd97dade2d0a63edd73b6034ea389310b712c7add7a5b2a11241'
AND (
token = 'HmDqk3NSY/FuG+i5sJHCwnhVG2JZyEhT5oTVBKNUBto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)