UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8VR4jPQ/mzmtUW7gxkgQ3uk4M0shg0ahDPAs5kWFVho='
WHERE
key_id = 'a717434a3a9504a5d55406d816b30fc5b27821a726ff9d2438930fc05f37cc25'
AND (
token = '8VR4jPQ/mzmtUW7gxkgQ3uk4M0shg0ahDPAs5kWFVho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)