UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xOCJPcLI6DyHxUusFa0vdCEVDf9c1Kfa22Yj3UnESLU='
WHERE
key_id = 'd9fd3b66df174769e4d02faa1fa5e1a65adc71a5ace26f24b2e322ee09ab0f1a'
AND (
token = 'xOCJPcLI6DyHxUusFa0vdCEVDf9c1Kfa22Yj3UnESLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)