UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E8RfUObRecsXiBhi4cjJDpMFNBsrBm6sXaRbaghwJxM='
WHERE
key_id = '65aeee18def568f8e0df62d3080458fc6b66e26c742878153f1d00f23c266f84'
AND (
token = 'E8RfUObRecsXiBhi4cjJDpMFNBsrBm6sXaRbaghwJxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)