UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6UZWMHdNfF7ux3SV6lHagnDKyNoHe9Q/PsiJ55OMnJI='
WHERE
key_id = '166278b89bab0539d6b7e8eb740faac49698fd00f231c2f4a9d41740703a3cb8'
AND (
token = '6UZWMHdNfF7ux3SV6lHagnDKyNoHe9Q/PsiJ55OMnJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)